home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Libris Britannia 4
/
science library(b).zip
/
science library(b)
/
PROGRAMM
/
DB_CLIPP
/
0828.ZIP
/
LOOK4.DOC
< prev
next >
Wrap
Text File
|
1987-05-12
|
3KB
|
74 lines
Look4 (c)
Onset Computer Services
282 La Casa Ave
San Mateo, CA 94402
(415) 573-1919
LOOK4.Com is a utility program which looks for string matches
within a given data base file. LOOK4 doesn't care what the
dBase field TYPE is (ie Character, DATE, Numeric, etc), and
there is no need to indicate what record number, what fields
to list, etc. Totally "No-Brainer" as far as dBase programming.
When matches are found within the DBF the ENTIRE RECORD is
both written to screen and to disk in a format which matches
the dBase Edit Mode showing both the field names and contents.
The scrolling screen display shows the fields where a match
occurs, and the on-disk version has a astrisk next to the
field which matches the user specs. Only the DBF records
with matches are displayed. The entire process runs
outside of dBase, but care must be taken that you're not
using a DBF when you use LOOK4 (ie working with multi-tasking
or networking.)
To use the program go to the DOS prompt and enter
"LOOK4" <RET> (Don't use quote marks)
You will be asked to supply a data base file name, with path if
necessary. If the file is not found the program signals the
error and quits. If the DBF file is found, you'll be asked
for the data to look for. Enter the data in the form desired
for an exact match, especially Upper/Lower case. If you're looking
for "Smith Corporation" don't enter "SMITH" (all upper case) or
"Smith Corp." (there's a period in there !) Given this
example, LOOK4 would find "Smith" as well as "Smith Co".
A simple text file is created which contains specs on the
DBF file (ie Last Update, Number of Records, Size in Bytes,
and Record Size) the specified string match, and the actual
records which match the search criteria. The text file's
name is "Look4.TXT" and is automatically overwritten without
warning each time LOOK4 runs. Matches are noted with an
asterisk (*) both on-screen and in the text file.
LOOK4 was created with the NON-Programmer in mind. Typically
an office support person who needs to get data out of a data
base file but has no reason to know commands such as:
"List First_Name, Last_name, CLT_Num for Clt_Num > 1200 .and. ;
Clt_num < 1500 to Print "
A query like that is child's play to a data base programmer
but not so easy for NON-DP types !
This program is distributed on-approval. It is NOT public domain
as it belongs to ONSET Computer Services.
If you use this program to help you make a living I would
appreciate it if you would also help ME make a living, too.
This program is FOR SALE at $25.00 per copy and I would love
to hear from you re. your ideas, improvements, custom
modifications, expensive enhancements, etc.
Onset Computer Services
282 La Casa Ave
San Mateo, CA 94402
(415) 573-1919